Occurs when the PivotTable list is explicitly disconnected from a data source, or the connection is changed to a different data source.
Private Sub Object_OnDisconnect()
Object The name of the PivotTable object that you are trapping this event for.